<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="Viewing Environment Information of the SQL Server Database">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002200006253.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="EN-US_TOPIC_0000002200006153">
<meta name="DC.Language" content="en-us">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>Viewing Environment Information of the SQL Server Database</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="EN-US_TOPIC_0000002200006153"></a><a name="EN-US_TOPIC_0000002200006153"></a>

<h1 class="topictitle1">Viewing Environment Information of the SQL Server Database</h1>
<div><p>After the SQL Server database is registered with the <span>OceanProtect</span>, you can view details about the database, the host where it resides, and the cluster or availability group to which it belongs on the management page.</p>
<div class="section"><h4 class="sectiontitle">Procedure</h4><ol><li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002199964685_uicontrol114088356363"><b><span id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002199964685_text1840913533616"><strong>Protection</strong></span> &gt; Databases &gt; SQL Server</b></span>.</span></li><li><span>View the details.</span><p><ul><li>On the <span class="uicontrol"><b>Cluster</b></span> tab page, view the SQL Server cluster information.<p>If a database in a cluster has been registered, the cluster information is displayed on the page.</p>
<div class="note"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p4219634163218">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_image1271105319486" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b9551254456">Operation</strong> and select a parameter to display it on the current page.</p>
</div></div>
<div class="p"><a href="#EN-US_TOPIC_0000002200006153__table1680311315916">Table 1</a> describes the detailed information.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000002200006153__table1680311315916"></a><a name="table1680311315916"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200006153__table1680311315916" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Cluster information</caption><colgroup><col style="width:20.31%"><col style="width:79.69000000000001%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.31%" id="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.69000000000001%" id="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.2 "><p>Name of a database cluster.</p>
<ul><li>If you click the cluster name, host members and all authenticated databases in the cluster are displayed.</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.1 "><p><span><strong>Status</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.2 "><div class="p">Cluster status.<ul><li><span>Online</span>: When a host is powered on and the client installed on the host is running properly, <span class="uicontrol"><b><span>Status</span></b></span> of the host is <span class="uicontrol"><b><span>Online</span></b></span>.<p>If there are online hosts in a cluster, the cluster status is <span class="uicontrol"><b><span>Online</span></b></span>.</p>
</li><li><span>Offline</span>: When a host is shut down or the client installed on the host is faulty, <span class="uicontrol"><b><span>Status</span></b></span> of the host is <span class="uicontrol"><b><span>Offline</span></b></span>.<p>If all hosts in a cluster are offline, the <strong>status </strong>of the cluster is <span class="uicontrol"><b><span>Offline</span></b></span>.</p>
</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.31%" headers="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.1 "><div class="p"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b827118125517">Tag</strong><div class="note" id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_note1330311543247"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p630385412417"><span id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_ph5374928181810">This parameter is available only in 1.6.0 and later versions.</span></p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="79.69000000000001%" headers="mcps1.3.2.2.2.2.1.1.4.2.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b1959642011219">--</strong> is displayed.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</li><li>On the <span class="uicontrol"><b><span><strong>Instances</strong></span></b></span> tab page, view the database instance information.<div class="note"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p4219634163218_1">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_image1271105319486_1" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b9551254456_1">Operation</strong> and select a parameter to display it on the current page.</p>
</div></div>
<div class="p"><a href="#EN-US_TOPIC_0000002200006153__table165331245151911">Table 2</a> describes the database instance information.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000002200006153__table165331245151911"></a><a name="table165331245151911"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200006153__table165331245151911" frame="border" border="1" rules="all"><caption><b>Table 2 </b>Database instance information</caption><colgroup><col style="width:20.330000000000002%"><col style="width:79.67%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.330000000000002%" id="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.67%" id="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><p>Name of a database instance.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><p><strong>Owning Host/Cluster</strong></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><p>Name of the host or cluster where a database instance resides.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><p><strong>Node IP Address</strong></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><p>IP address of the host where a database instance resides.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><p><span><strong>Version</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><p>Version of the database where an instance is located.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><p>If an SLA is associated with the database, the SLA name is displayed. Otherwise, <span class="uicontrol" id="EN-US_TOPIC_0000002200006153__en-us_topic_0000001656761205_uicontrol4603205811816"><b>--</b></span> is displayed. </p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><div class="p">Whether a backup job is successfully executed based on the backup interval or backup window set in the SLA.<ul id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_ul1823814519293"><li id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li9238184572919"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b1092516394564">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li><li id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li189142052112912"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b541520442564">Missed</strong>: If the backup time does not meet the backup time window or backup interval requirements, for example, if the backup interval set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup interval or backup window.</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><p><span><strong>Protection Status</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><p>Whether an instance is protected. </p>
<ul><li><span><strong>Unprotected</strong></span>: The instance is not associated with an SLA, or the database is associated with an SLA but protection is disabled.</li><li><strong><span><strong>Protected</strong></span></strong>: The instance is associated with an SLA and protection is activated.</li><li><strong><span><strong>Creating</strong></span></strong>: The instance is associated with an SLA and protection is being created.</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.330000000000002%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.1 "><div class="p"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b827118125517_1">Tag</strong><div class="note" id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_note1330311543247_1"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p630385412417_1"><span id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_ph5374928181810_1">This parameter is available only in 1.6.0 and later versions.</span></p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="79.67%" headers="mcps1.3.2.2.2.2.1.2.3.2.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b1959642011219_1">--</strong> is displayed.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<ol type="a"><li>Click the name and check the overview, copy information, and jobs. <ul><li>Overview<p>Displays the SLA information, job execution time, total number of copies, and information about nodes and databases.</p>
</li><li>Copy data<p>You can search for copies by year, month, or day.</p>
<p>If <span><img src="en-us_image_0000002164765246.png"></span> is displayed below the time, copies exist at that time.</p>
</li><li>Job<p>Backup and restoration jobs are displayed.</p>
</li></ul>
</li></ol>
</li><li>On the <span class="uicontrol"><b><span><strong>Availability Group</strong></span></b></span> tab page, view the database availability group information.<div class="note"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p4219634163218_2">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_image1271105319486_2" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b9551254456_2">Operation</strong> and select a parameter to display it on the current page.</p>
</div></div>
<div class="p"><a href="#EN-US_TOPIC_0000002200006153__table977033115154">Table 3</a> describes details about a database availability group.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000002200006153__table977033115154"></a><a name="table977033115154"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200006153__table977033115154" frame="border" border="1" rules="all"><caption><b>Table 3 </b>Availability group information</caption><colgroup><col style="width:21.18%"><col style="width:78.82000000000001%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="21.18%" id="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="78.82000000000001%" id="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>Name of a database availability group.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><strong>Owning Cluster</strong></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>Name of the cluster to which a database availability group belongs.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>If an availability group is associated with an SLA, the SLA name is displayed. Otherwise, <span class="uicontrol"><b>--</b></span> is displayed. </p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><div class="p">Whether a backup job is successfully executed based on the backup interval or backup window set in the SLA.<ul id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_ul1823814519293_1"><li id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li9238184572919_1"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b1092516394564_1">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li><li id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li189142052112912_1"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b541520442564_1">Missed</strong>: If the backup time does not meet the backup time window or backup interval requirements, for example, if the backup interval set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup interval or backup window.</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><p><span><strong>Protection Status</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>Whether an availability group is protected. </p>
<ul><li><span><strong>Unprotected</strong></span>: The availability group is not associated with an SLA, or it is associated with an SLA but protection is disabled.</li><li><span><strong>Protected</strong></span>: The availability group is associated with an SLA and protection is activated.</li><li><span><strong>Creating</strong></span>: The availability group is associated with an SLA and protection is being created.</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="21.18%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.1 "><div class="p"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b827118125517_2">Tag</strong><div class="note" id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_note1330311543247_2"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p630385412417_2"><span id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_ph5374928181810_2">This parameter is available only in 1.6.0 and later versions.</span></p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="78.82000000000001%" headers="mcps1.3.2.2.2.2.1.3.3.2.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b1959642011219_2">--</strong> is displayed.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<ol type="a"><li>Click the name and check the overview, copy information, and jobs. <ul><li>Overview<p>Displays SLA information, job execution time, total number of copies, and protected objects.</p>
</li><li>Copy data<p>You can search for copies by year, month, or day.</p>
<p>If <span><img src="en-us_image_0000002199971861.png"></span> is displayed below the time, copies exist at that time.</p>
</li><li>Job<p>Backup and restoration jobs are displayed.</p>
</li></ul>
</li></ol>
</li><li>View the database information on the <span class="uicontrol"><b><span><strong>Databases</strong></span></b></span> tab.<p>The information about the scanned database is displayed.</p>
<div class="note"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p4219634163218_3">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_image1271105319486_3" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b9551254456_3">Operation</strong> and select a parameter to display it on the current page.</p>
</div></div>
<div class="p"><a href="#EN-US_TOPIC_0000002200006153__table2382789197">Table 4</a> describes the database information.
<div class="tablenoborder"><a name="EN-US_TOPIC_0000002200006153__table2382789197"></a><a name="table2382789197"></a><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200006153__table2382789197" frame="border" border="1" rules="all"><caption><b>Table 4 </b>Database information</caption><colgroup><col style="width:20.380000000000003%"><col style="width:79.62%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="20.380000000000003%" id="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1"><p>Parameter</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="79.62%" id="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2"><p>Description</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1 "><p><span><strong>Name</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2 "><p>Database name.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1 "><p><span><strong>Owning Host/Cluster</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2 "><p>Name of the host or cluster where a database resides.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1 "><p><span><strong>Owning Instance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2 "><p>Name of a single instance or cluster instance.</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1 "><p><span><strong>SLAs</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2 "><p>If an SLA is associated with the database, the SLA name is displayed. Otherwise, <span class="uicontrol"><b>--</b></span> is displayed. </p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1 "><p><span><strong>SLA Compliance</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2 "><div class="p">Whether a backup job is successfully executed based on the backup frequency or backup window set in the SLA.<ul id="EN-US_TOPIC_0000002200006153__en-us_topic_0000001656691393_en-us_topic_0000001656771381_ul1823814519293"><li id="EN-US_TOPIC_0000002200006153__en-us_topic_0000001656691393_en-us_topic_0000001656771381_li9238184572919"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000001656691393_en-us_topic_0000001656771381_b62003482519">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup frequency requirements and the backup job is executed successfully, SLA compliance is met.</li><li id="EN-US_TOPIC_0000002200006153__en-us_topic_0000001656691393_en-us_topic_0000001656771381_li189142052112912"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000001656691393_en-us_topic_0000001656771381_b572213321552">Missed</strong>: If the backup time does not meet the backup time window or backup frequency requirements, for example, if the backup frequency set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup frequency or backup window.</li></ul>
</div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1 "><p><span><strong>Protection Status</strong></span></p>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2 "><p>Indicates whether the database is protected. </p>
<ul><li><span><strong>Unprotected</strong></span>: The database is not associated with an SLA, or the database is associated with an SLA but protection is disabled.</li><li><span><strong>Protected</strong></span>: The database is associated with an SLA and protection is activated.</li><li><span><strong>Creating</strong></span>: The database is associated with an SLA and protection is being created.</li></ul>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="20.380000000000003%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.1 "><div class="p"><strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b827118125517_3">Tag</strong><div class="note" id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_note1330311543247_3"><span class="notetitle"> NOTE: </span><div class="notebody"><p id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_p630385412417_3"><span id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_ph5374928181810_3">This parameter is available only in 1.6.0 and later versions.</span></p>
</div></div>
</div>
</td>
<td class="cellrowborder" valign="top" width="79.62%" headers="mcps1.3.2.2.2.2.1.4.4.2.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200006153__en-us_topic_0000002164820458_b1959642011219_3">--</strong> is displayed.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<ol type="a"><li>Click the name and check the overview, copy information, and jobs. <ul><li>Overview<p>The SLA information, job execution time, and total number of copies are displayed.</p>
</li><li>Copy data<p>You can search for copies by year, month, or day.</p>
<p>If <span><img src="en-us_image_0000002164605534.png"></span> is displayed below the time, copies exist at that time.</p>
</li><li>Job<p>Backup and restoration jobs are displayed.</p>
</li></ul>
</li></ol>
</li></ul>
</p></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="en-us_topic_0000002200006253.html">SQL Server Database Environment</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">Copyright &copy; Huawei Technologies Co., Ltd.</div></body>
</html>